select d.last_name, d.first_name, p.prevention_date, l.val from preventionsExt l, demographic d, preventions p where p.demographic_no = d.demographic_no and l.prevention_id = p.id and p.deleted = 0 and ( l.val like '%{search}%') order by d.last_name;